Returns or sets a value that determines if the properties that set the current data point are incremented during data entry without manually setting the Column and Row properties.
Syntax
object.AutoIncrement [ = boolean]
The AutoIncrement property syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
boolean | A Boolean expression that specifies whether the current data point is incremented, as described in Settings. |
Settings
The settings for boolean are:
Setting | Description |
True | When the Data property is changed, the Row property updates to the next row in the column. If you are at the end of a column, the Column property increments to the next column. |
False | (Default) The current data point is not incremented. |